package com.yangjun.dao.mybatis.mapper.usermanage;

import java.util.List;
import java.util.Map;

import org.apache.ibatis.annotations.Param;

import com.yangjun.entity.report.DvExcelFieldDefinitionEntity;
import com.yangjun.entity.usermanage.ExcelReportDimEntity;
import com.yangjun.entity.usermanage.ExcelReportEntity;
import com.yangjun.entity.usermanage.ExcelRoleEntity;
import com.yangjun.entity.usermanage.ExcelRoleReportEntity;
import com.yangjun.entity.usermanage.ExcelUserFieldEntity;
import com.yangjun.entity.usermanage.ExcelUserRoleEntity;
import com.yangjun.entity.usermanage.UsersEntity;

public interface ExcelRoleManagerMapper {
	
	
	List<ExcelRoleEntity> getCurrentExcelRoleInfo(Map<String, Object> parameter);
	List<ExcelRoleEntity> getExcelNormalRoleInfo();
	List<ExcelReportEntity> getAllExcelReportInfo();
	List<ExcelRoleReportEntity> getRoleReportInfo(@Param(value="roleid") int roleid);
	ExcelRoleReportEntity  roleExistField(@Param(value="roleid") int roleid,@Param(value="excelId") String excelId);
	
	
	
	List<DvExcelFieldDefinitionEntity> queryCategory(@Param(value="excelId") String excelId);
	List<DvExcelFieldDefinitionEntity> queryField(@Param(value="excelId") String excelId);
	List<ExcelReportDimEntity> queryDim(@Param(value="excelId") String excelId);
	
	List<ExcelUserRoleEntity> getAllUserRoleInfo(Map<String, Object> parameter);
	List<ExcelRoleEntity> getNormalSonRoleInfo(@Param(value="username") String username);
	UsersEntity getUseridAndRealnameOfUsername(@Param(value="username") String username);
	List<Integer> getUserRoleId(@Param(value="username") String username);
	List<Integer> getUserRoleIdByUserId(@Param(value="userid") String userid);
	List<ExcelUserFieldEntity> getUserExcelField(@Param(value="userid") String userid,@Param(value="reportType") String reportType);

	List<String> getUserExcelDim(@Param(value="userid") String userid,@Param(value="reportType")  String reportType);
	List<String> getUserExcelReportType(@Param(value="userid") String userid);
}
